Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
PersonPartyID (FK)(PK) | A unique, system assigned identity for a Party. | ID_PRTY_PRS | Identity | integer | Person(PA_PRS) |
SegmentationPrecedenceOrder (PK) | A retailer assigned value that tells what level of importance is assigned to this PersonActivityInterest by a retailer for the purpose of segmenting customers. This value must be a positive, whole number and must be UNIQUE within the PersonPartyID. | AI_SGMT_PRCDN_ORD | LineNumber | smallint | |
ActivityInterestCode (FK) | A lookup value that designates a valid activity or interest code used to segment customers. The code list must be defined by the retailer. | CD_ACTV_INTRST | Code | varchar(20) | ActivityInterest(CO_ACTV_INTRST) |
IntensityLevelCode | A code that indicates the level of interest or enthusiasm a person has in an activity or interest. Sample Values: LOW - interested but not fully engaged MEDIUM - interested and engaged HIGH - interested, enagaged and obsessed | CD_INTSY_LV | Code | varchar(20) | |
LeisureProfessionalTypeCode | A code that characterizes the involvement of a person in an activity (or interest) as professional (i.e. it's an aspect of their vocation) or liesure (something they're involved with for fun). Sample Values: PROFESSIONAL LIESURE OTHER | CD_LSUR_PRFSL_TYP | Code | varchar(20) | |